UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jKRdouhwhd/frKIaZMm5pDl/pRDbvxLhWWAX90yoyI='
WHERE
key_id = 'c85efa58f13796cc8136ca91feeb2eef757b0baea5c0529177e0a3b836fab18e'
AND (
token = '6jKRdouhwhd/frKIaZMm5pDl/pRDbvxLhWWAX90yoyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)