UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xPW/pfmvLG8lbK3zwrA3xl2yeKLpxu+Wu+2HZXZq9yg='
WHERE
key_id = 'd1a1d7eccdfff6b73dc4be108b3ec426b09965eee7aac2b59ea715c62d45796a'
AND (
token = 'xPW/pfmvLG8lbK3zwrA3xl2yeKLpxu+Wu+2HZXZq9yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)