UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm65cROM2ax/6SOeI8zHl3iAN3fqc27/1FAPkggq1O4M='
WHERE
key_id = '31f6177799784a9f409a06ad54543dc8d6b7603d834695c4cac38bc73578c4ea'
AND (
token = 'm65cROM2ax/6SOeI8zHl3iAN3fqc27/1FAPkggq1O4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)