UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c7WOyMnGOQIJPw6Co5tGoNFRixNP6VzkgPFO1XR6zxg='
WHERE
key_id = '24c7509e5e0ab16d5166a6f1890edd4eee1d0d2f0b430e5e12886bd139c37791'
AND (
token = 'c7WOyMnGOQIJPw6Co5tGoNFRixNP6VzkgPFO1XR6zxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)