UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JtOv1uRB7b/YdM9YmLi20JOPzIsTyVVaRDEb0IgLSac='
WHERE
key_id = '127089451b1f373291e9f91572c3b388751cf15f6da866480fd177edba75f38b'
AND (
token = 'JtOv1uRB7b/YdM9YmLi20JOPzIsTyVVaRDEb0IgLSac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)