UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06IcX3ua10VUo5Zg2ozfPh1CYZwfb5wZFE4GiFCKTIM='
WHERE
key_id = '186d3ffa90842ee33a9089a6a41b7dc2f8bcbf822ef50ccc674cae96b670374f'
AND (
token = '06IcX3ua10VUo5Zg2ozfPh1CYZwfb5wZFE4GiFCKTIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)