UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/3Rddt1R1rDtCyiRYgDSyPRRMG+gWILWdlMUwTbLW78='
WHERE
key_id = 'a7a66a5c38d63bfa5aa9ebb6d180d79a3d50064055adf54e89a93a2fe015a20a'
AND (
token = '/3Rddt1R1rDtCyiRYgDSyPRRMG+gWILWdlMUwTbLW78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)