UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e1TMEz3H36mrJ6e2IyMSXMPqylC3INhY40Ej41sMO+4='
WHERE
key_id = '2730edfeb39f7ab10087143757392ccd182f251b1ab40525deb6bc37e27fbc9c'
AND (
token = 'e1TMEz3H36mrJ6e2IyMSXMPqylC3INhY40Ej41sMO+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)