UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPW4vuL7wjQLqqawo3NeXWTk/UC/VD/p8qeVf6HK3vY='
WHERE
key_id = 'd1fe3b9bcdd00ef37f188a5c00132764dc55f30eec904df8b7ca60fcb9b384fc'
AND (
token = 'gPW4vuL7wjQLqqawo3NeXWTk/UC/VD/p8qeVf6HK3vY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)