UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sve3bETbJnUuL4LCmy3Nw+dwUNoYYFZhUDx/yue4co='
WHERE
key_id = 'b9b0ebfb27ad77e7f85a33b428bf3a3dcd39d1aa640298b0467583a19704a189'
AND (
token = '7sve3bETbJnUuL4LCmy3Nw+dwUNoYYFZhUDx/yue4co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)