UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgeSHXvYC4+aFQIespUE9rrvmVAVeLUnMXpPQb4V7so='
WHERE
key_id = '00de4eb28802ee9e9b4a12f6c69ee94564f519cef438914b5be32d8c0e025b2e'
AND (
token = 'YgeSHXvYC4+aFQIespUE9rrvmVAVeLUnMXpPQb4V7so='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)