UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yt3AHKJhadX9bmY52LBSxmOlG6YO5t2BVmSTP6X5rX0='
WHERE
key_id = '48e7c895094659a935c707b5de559f2e88b26523f6fd372df0b7c503cf4094f9'
AND (
token = 'Yt3AHKJhadX9bmY52LBSxmOlG6YO5t2BVmSTP6X5rX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)