UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iMD221KsVGzGy5TPJo2WhThz3MTx2Px3TL/3MWJ1/D4='
WHERE
key_id = '6a416e5c4c806e6ca2cd04735be86477c432086041a403fd5c9689c701f698d5'
AND (
token = 'iMD221KsVGzGy5TPJo2WhThz3MTx2Px3TL/3MWJ1/D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)