UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mEGi1CjBiAqp6azy3/et9rku4KA4DXKlYcMe7JDNgUA='
WHERE
key_id = '47f291e6ff9567b798ee044076631a2784ccffc5551da60749d8918d9d17466c'
AND (
token = 'mEGi1CjBiAqp6azy3/et9rku4KA4DXKlYcMe7JDNgUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)