UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KWNrG9X5h0Mae/Xb8Z/otpJUFved2ceFb1n+k7xdm3g='
WHERE
key_id = 'ae38f7dd9eafcc61ee973e9f522f51b0ddb98a595d65e4250aa91e994bd03a89'
AND (
token = 'KWNrG9X5h0Mae/Xb8Z/otpJUFved2ceFb1n+k7xdm3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)