UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tzn8Uw0ybGO7F8zMSbppKAIq80BTepPYoopa7liyUAA='
WHERE
key_id = '13f6394523767c6ed8e4978140ee92f7391702ca3f210950215d30b5442b7f3d'
AND (
token = 'tzn8Uw0ybGO7F8zMSbppKAIq80BTepPYoopa7liyUAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)