UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIZmmfb2QW6Z6pI5rCdG8zz9iIsjNS0tNoficI+djqI='
WHERE
key_id = 'ed6e8349239f24a7672deebb951f62d2af300e32039de64509bdab1f98a56d71'
AND (
token = 'zIZmmfb2QW6Z6pI5rCdG8zz9iIsjNS0tNoficI+djqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)