UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3QZk+ZShNyh29A38hFiG/oXhnt0Zz4OVwm8BEE4QuA='
WHERE
key_id = 'a0148cc44e6e6c875ff5c0be24b06584fb1dfa9bb539e312ca573a18bc466bdf'
AND (
token = 'W3QZk+ZShNyh29A38hFiG/oXhnt0Zz4OVwm8BEE4QuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)