UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JyFGAHiec8fEfOfao1akge3PAGcU4MmKfVuHZXcpvo='
WHERE
key_id = '362a05f9a089a96e04dd5d01452567a85ad81cabe31105df880f45587287fea3'
AND (
token = '8JyFGAHiec8fEfOfao1akge3PAGcU4MmKfVuHZXcpvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)