UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lHDAw1x5m1sZ93SYV1GYW64ot1O47Jv2+5mhHPYZSas='
WHERE
key_id = 'bbb5f0f9792b4d1264a868544983b6281ad8bb775edeeca0b4ea3a9ae53095cb'
AND (
token = 'lHDAw1x5m1sZ93SYV1GYW64ot1O47Jv2+5mhHPYZSas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)