UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pg9JbbRlUKSy9D7VgpujzDG+5RoZEpnLJ9cuNbiZ6Q0='
WHERE
key_id = '7cd1e2b1bcffb1bd26d111db42d153cfed426717840504ecb5832a7e866a46b3'
AND (
token = 'pg9JbbRlUKSy9D7VgpujzDG+5RoZEpnLJ9cuNbiZ6Q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)