UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KyYGFcne1wdGVeofCuqR1uRw2nl9ZspoRtzS8UfxIE='
WHERE
key_id = 'bc4b3524f105df62d21f8a02b2fe3cf9c3b3afdefca14a81b37bcd90ed7d7d9c'
AND (
token = '/KyYGFcne1wdGVeofCuqR1uRw2nl9ZspoRtzS8UfxIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)