UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o1awc9KegU9vug8WXRSyYnn3XGD8EfuhAq+wjrwlhcY='
WHERE
key_id = '8e2d907cf7ec6744b76b8f30d4b014812ef597e328eac7d1de65d846744e31f2'
AND (
token = 'o1awc9KegU9vug8WXRSyYnn3XGD8EfuhAq+wjrwlhcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)