UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VLKEuXoc+gcElwm5CMhtq8rJwdWGu5QXuRFJ904RqF8='
WHERE
key_id = '47f03f90b7d03e41a0118545741d777f3c04e9818c45efe600b7e4c30dc09d00'
AND (
token = 'VLKEuXoc+gcElwm5CMhtq8rJwdWGu5QXuRFJ904RqF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)