UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4uTDgNx5cQQAW3oq5qBXtCf9QyPsDU03apP2h08wDtg='
WHERE
key_id = '1e2f8f750d8fdf4f6864161ebbdb5d7aeb75974d76b0e169f93a60b8f74190be'
AND (
token = '4uTDgNx5cQQAW3oq5qBXtCf9QyPsDU03apP2h08wDtg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)