UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lkEF4+uJGorJ7QHLntXrnAh/SRakrKYV+LgvA0vaLhw='
WHERE
key_id = '5d911c4e0420c01d28267c1b9818cf0ac1923886082494c88f8e81ca1ebf3451'
AND (
token = 'lkEF4+uJGorJ7QHLntXrnAh/SRakrKYV+LgvA0vaLhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)