UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7jgZjWt/auXu7XyEJjcLXFvm3FLcue1oUVupgFZXzCY='
WHERE
key_id = 'b8ea61e0184edc1165625566230c7a76bac790a4c97ffc5f92a2eec2e4a10ec7'
AND (
token = '7jgZjWt/auXu7XyEJjcLXFvm3FLcue1oUVupgFZXzCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)