UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rm3y3l3LEIovs4dxwSfKYke7Kd8tbgV/dcXHRTvbPC0='
WHERE
key_id = '9da4256d318e74a693278f322c6f7c52e35f4a28b86b14f4d02029d8cb42afaf'
AND (
token = 'Rm3y3l3LEIovs4dxwSfKYke7Kd8tbgV/dcXHRTvbPC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)