UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dmziGGKgUq8/YtcRmkz0waC/KsrYsI5Lk6eWFYKuxo='
WHERE
key_id = 'abc3c093cda2cbb02d80a18e0da00d87df8302a19de1e2bba6c6857ceb6ec6bc'
AND (
token = '9dmziGGKgUq8/YtcRmkz0waC/KsrYsI5Lk6eWFYKuxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)