UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9am5+hKO0XughmhNBZVaboLyTvGDuWoBd8EdCWe+y8w='
WHERE
key_id = 'dff56721b284ce286f16b3c9b3b11426c1b2c8844caa03cd93a1b9eca2250175'
AND (
token = '9am5+hKO0XughmhNBZVaboLyTvGDuWoBd8EdCWe+y8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)