UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZdmZMqpYgM9ayM1OdvAS73oiMHAp4B5UclGy+D07uE='
WHERE
key_id = 'bb9712e430d77fa86c0e318f2e87283c643fce355c77aea4f6263b7e956804a5'
AND (
token = '9ZdmZMqpYgM9ayM1OdvAS73oiMHAp4B5UclGy+D07uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)