UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7vDrJnfENljAXw4hHLyGFt50iJsUzXOCOr9n6dRdYvk='
WHERE
key_id = 'bd5a6dadfc7f9940d1c5399c3869ec1ef669a87111b6f9942ae75c28f05acbf3'
AND (
token = '7vDrJnfENljAXw4hHLyGFt50iJsUzXOCOr9n6dRdYvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)