UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DiobVf13AxFFFLmosqaiV1veAhOqZUywtHVwzjsK7HA='
WHERE
key_id = 'a8b19c5241f5b29d0aa18db19db4251f1ab4c78df0b79e76da54b62eb9a91f51'
AND (
token = 'DiobVf13AxFFFLmosqaiV1veAhOqZUywtHVwzjsK7HA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)