UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0SKdXDsb9FKzxOPvxdpAHDM4fzDgxCIzE4xBbSYGcTY='
WHERE
key_id = '9c9d408335f6d9818d07e13cae084f458fa55a35b4fc1a394335948920c41007'
AND (
token = '0SKdXDsb9FKzxOPvxdpAHDM4fzDgxCIzE4xBbSYGcTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)