UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vkPG5FBJye14rhhQ/95CbwiZJPcmGAWJ7csvbfA4vo8='
WHERE
key_id = '6d2987d11d66a85b3c33e0eb4ab1b7699fc81a946f324112107616f15d6c5178'
AND (
token = 'vkPG5FBJye14rhhQ/95CbwiZJPcmGAWJ7csvbfA4vo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)