UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hw1ckazaee0RQh0pjv6BTJ0tCJvxoNlk5EFVLZgjCA='
WHERE
key_id = '6470d8127eef47cbe731604f77a8c6ed2e78b315207f6ba3c49f8686e5125c6c'
AND (
token = '8hw1ckazaee0RQh0pjv6BTJ0tCJvxoNlk5EFVLZgjCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)