UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZSpzM6KoAqXlKpRnLbAhpeHqWMAgYDojPy8tb1P3hE0='
WHERE
key_id = 'ae2eae9fb13d4011a10b62205f3848ebb937ee228a9f99d00f3dffb93949cf4c'
AND (
token = 'ZSpzM6KoAqXlKpRnLbAhpeHqWMAgYDojPy8tb1P3hE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)